﻿<%@ Page Title="" Language="C#" MasterPageFile="~/masterPage.Master" AutoEventWireup="true" CodeFile="cksb.aspx.cs" Inherits="cksb" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
    DataSourceID="SqlDataSourcesb" EnableModelValidation="True" AllowPaging="True" 
        Width="514px">
        <Columns>
            <asp:BoundField DataField="s_Name" HeaderText="设备名" 
                SortExpression="s_Name" />
            <asp:HyperLinkField DataNavigateUrlFields="s_jfID" 
                DataNavigateUrlFormatString="jfView.aspx?jfID={0}" DataTextField="j_Name" 
                HeaderText="机房名" />
            <asp:BoundField DataField="c_Name" HeaderText="分类" 
                SortExpression="c_Name" />
            <asp:BoundField DataField="s_zy" HeaderText="作用" SortExpression="s_zy" />
            <asp:BoundField DataField="s_kfsj_s" HeaderText="开放时间" 
                SortExpression="s_kfsj_s" />
            <asp:BoundField DataField="s_kfsj_e" HeaderText="关闭时间" 
                SortExpression="s_kfsj_e" />
        </Columns>
    </asp:GridView>
<asp:SqlDataSource ID="SqlDataSourcesb" runat="server" 
    ConnectionString="<%$ ConnectionStrings:LabInfoManageSystemConnectionString %>" 
    
        
        SelectCommand="SELECT sbInfo.sbID, sbInfo.s_jfID, jfInfo.j_Name, classInfo.c_Name, sbInfo.s_Name, sbInfo.s_zy, sbInfo.s_kfsj_s, sbInfo.s_kfsj_e FROM sbInfo INNER JOIN classInfo ON sbInfo.s_class = classInfo.cID INNER JOIN jfInfo ON jfInfo.jfID = sbInfo.s_jfID"></asp:SqlDataSource>
</asp:Content>

